#include "SQLTable.h"
#include "../RealObject/GroupProduct.h"
class CSGroupTbl : public CSqlTable
{
public:
	CSGroupTbl();
public:
	static int  getMaxCode();
	static bool addNewGroup(const CGroupProduct* pGroup);
	static bool deleteGroup(const CString& sCode);
	static CGroupProduct* getGroup(CString sCode);

	static vector<CGroupProduct*> getListGroup();
	static vector<CGroupProduct*> getListGroupByType(const int& nType);
};